<?php
include_once '../connexpdo.php';
$vretour = "";
$requete = 'SELECT * FROM appels as a
INNER JOIN praticiens AS p ON a.idclient = p.id
INNER JOIN problematique AS pr ON a.idproblematique = pr.id
INNER JOIN priorite AS prio ON a.idpriorite = prio.id
INNER JOIN cloturer AS c ON a.idcloturer = c.id
INNER JOIN utilisateurs AS u ON a.idtech = u.id
WHERE idappels=' . $_POST ['idEnvoiAjax'];
$result = $connexion->query ( $requete );
$result->setFetchMode ( PDO::FETCH_OBJ );
while ( $OneRow = $result->fetch () ) {
	$vretour .= '<table class="table table-hover">
		<th>Praticiens</th>
		<th>Problématique</th>
		<th>Duree</th>
		<th>Date</th>
		<th>Technicien</th>
		<tr ><td><input type="hidden" name="modifier" value="' . $OneRow->idAppels . '">' . $OneRow->nom . " " . $OneRow->prenom . '</td>

<td>' . $OneRow->nature . '</td>
<td>' . $OneRow->duree . '</td>
<td>' . $OneRow->dateDebut . '</td>
<td>' . utf8_encode ( $OneRow->identifiant ) . '</td>
</tr>
</table>
<p>Commentaires : </p>
<textarea disabled style="margin: 0px 0px 10px; width: 1354px; height: 160px; max-width: 1336px;">' . $OneRow->commentaires;
}

echo $vretour;